Google Links
Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge
Elements and Performance Criteria
- Design database
- Develop database
- Develop queries, forms and reports
- Test and finalise database
- Populate database with sample dataset for testing, meeting organisational requirements for speed and accuracy
- Assess and document effectiveness of data relationships, query forms and reports, assessing against organisational and task requirements
- Document and address any errors in database design
- Name and store database in accordance with organisational policies and procedures relating to data security, and exit the application without data loss or damage
- Confirm database readiness with appropriate personnel
- Identify organisational and task requirements to confirm scope and functionality of database design, including data redundancy
- Develop a logical data model to identify and classify data into types in accordance with organisational and task requirements
- Select appropriate digital application/platform according to organisational and task requirements, available resources, and required scope and functionality of database
- Create and document proposed database structure, and share with appropriate personnel in accordance with organisational policies and procedures
- Seek feedback on proposed database design from appropriate personnel
- Set field attributes according to data type and link databases by a common field in accordance with database application usage
- Assign primary key to uniquely identify data
- Assign foreign keys to establish associations between data, in accordance with organisational and task requirements
- Use software functions and formulae to meet organisational and task requirements
- Create password and access system according to organisational policies and procedures relating to data security
- Access and use application help functions to overcome intermediate-level issues with database design and production, where required